CREATING KEY PERFORMANCE INDICATORS 12

KPI 1 - Total Class Count


Steps

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual to the dashboard.

Ø  Click on 'Total Class Sections' Measure and drag it into the fields.

Ø  General: X - Position = 10, Y - Position = 102, Width = 197, Height = 102

Ø  Data Label: Color = #070F25,  Value Decimal = Auto, Font Size = 27,  Font type = DIN

Ø  Category = OFF

Ø  Title = ON,  Text Title = "Total Class Cnt", Font Color = #FFFFFF, Background Color = #596DBD,   Font Size = 15 and Font Family = Cambria Math, Alignment = Center

Ø  Background OFF

Ø  Border ON, Color = #B3B3B3


GIF 1 - Total Class Count


GIF 2 - Total Class Count



GIF 3 - Total Class Count


Note: Your  values might be different because they will be showing current numbers

KPI2 - Impact

Steps

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual to the dashboard.

Ø  Click on 'Impact' Measure and drag it into the fields.

Ø  General: X - Position = 10, Y - Position = 203, Width = 197, Height = 102

Ø  Data Label: Color = click on fx and format by 'Field value' Based on Field = .ArrowImpactColor

Value Decimal = Auto, Font Size = 27,  Font type = DIN

Ø  Category = OFF

Ø  Title = ON,  Text Title = "Impact", Font Color = #FFFFFF, Background Color = #596DBD,   Font Size = 15 and Font Family = Cambria Math, Alignment = Center

Ø  Background OFF

Ø  Border ON, Color = #B3B3B3

GIF 1 - Impact

Duplicate Total Class Cnt KPI > Change the fields to impact > change title


GIF 2 - Impact

Format data label


GIF 3 -

Add and format indicator



GIF 4

Indicator position

Ø  General: X - Position = 0, Y - Position = 217, Width = 53, Height = 51



KPI 3 - Rolling 6 Months Avg & Indicator

Steps

Ø  Open Visualization Pane

Ø  Select Visual Card

Ø  Drag the visual to the dashboard.

Ø  Click on 'Impact' Measure and drag it into the fields.

Ø  General: X - Position = 10, Y - Position = 305, Width = 197, Height = 102

Ø  Data Label: Color = click on fx and format by 'Field value' Based on Field = .ArrowColor6Month

Value Decimal = Auto, Font Size = 27,  Font type = DIN

Ø  Category = OFF

Ø  Title = ON,  Text Title = "Rolling 6 Months Avg", Font Color = #FFFFFF, Background Color = #596DBD,   Font Size = 15 and Font Family = Cambria Math, Alignment = Center

Ø  Background OFF

Ø  Border ON, Color = #B3B3B3

GIF 1- Rolling 6 Months Avg & Indicator

Follow same steps for KPI 2



GIF 2- Rolling 6 Months Avg & Indicator

Indicator position

Ø  General: X - Position = 0, Y - Position = 330, Width = 53, Height = 51Dashboard should look like this 




Your  dashboard should be looking like this:


How to create card visual

https://www.youtube.com/watch?v=8DvVUjwhPKE